
USE [MSPetShop]

declare @hostName as varchar(25)

set @hostname = HOST_NAME() + '\ASPNET'

exec sp_grantlogin @hostname

exec sp_grantdbaccess @hostname

exec sp_addrolemember 'db_owner', @hostname
